<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/xhtml;charset=UTF-8"/>
<title>MTCDElggPlugin: /home/nicola/public_html/elgg/mod/mtcd/views/default/widgets/recommender/connection.php Source File</title>

<link href="tabs.css" rel="stylesheet" type="text/css"/>
<link href="doxygen.css" rel="stylesheet" type="text/css" />
<link href="navtree.css" rel="stylesheet" type="text/css"/>
<script type="text/javascript" src="jquery.js"></script>
<script type="text/javascript" src="resize.js"></script>
<script type="text/javascript" src="navtree.js"></script>
<script type="text/javascript">
  $(document).ready(initResizable);
</script>
<link href="search/search.css" rel="stylesheet" type="text/css"/>
<script type="text/javascript" src="search/search.js"></script>
<script type="text/javascript">
  $(document).ready(function() { searchBox.OnSelectItem(0); });
</script>

</head>
<body>
<div id="top"><!-- do not remove this div! -->


<div id="titlearea">
<table cellspacing="0" cellpadding="0">
 <tbody>
 <tr style="height: 56px;">
  
  
  <td style="padding-left: 0.5em;">
   <div id="projectname">MTCDElggPlugin
   &#160;<span id="projectnumber">0.1</span>
   </div>
   
  </td>
  
  
  
 </tr>
 </tbody>
</table>
</div>

<!-- Generated by Doxygen 1.7.5 -->
<script type="text/javascript">
var searchBox = new SearchBox("searchBox", "search",false,'Search');
</script>
  <div id="navrow1" class="tabs">
    <ul class="tablist">
      <li><a href="index.html"><span>Main&#160;Page</span></a></li>
      <li><a href="annotated.html"><span>Classes</span></a></li>
      <li class="current"><a href="files.html"><span>Files</span></a></li>
      <li>
        <div id="MSearchBox" class="MSearchBoxInactive">
        <span class="left">
          <img id="MSearchSelect" src="search/mag_sel.png"
               onmouseover="return searchBox.OnSearchSelectShow()"
               onmouseout="return searchBox.OnSearchSelectHide()"
               alt=""/>
          <input type="text" id="MSearchField" value="Search" accesskey="S"
               onfocus="searchBox.OnSearchFieldFocus(true)" 
               onblur="searchBox.OnSearchFieldFocus(false)" 
               onkeyup="searchBox.OnSearchFieldChange(event)"/>
          </span><span class="right">
            <a id="MSearchClose" href="javascript:searchBox.CloseResultsWindow()"><img id="MSearchCloseImg" border="0" src="search/close.png" alt=""/></a>
          </span>
        </div>
      </li>
    </ul>
  </div>
  <div id="navrow2" class="tabs2">
    <ul class="tablist">
      <li><a href="files.html"><span>File&#160;List</span></a></li>
      <li><a href="globals.html"><span>File&#160;Members</span></a></li>
    </ul>
  </div>
</div>
<div id="side-nav" class="ui-resizable side-nav-resizable">
  <div id="nav-tree">
    <div id="nav-tree-contents">
    </div>
  </div>
  <div id="splitbar" style="-moz-user-select:none;" 
       class="ui-resizable-handle">
  </div>
</div>
<script type="text/javascript">
  initNavTree('connection_8php.html','');
</script>
<div id="doc-content">
<div class="header">
  <div class="headertitle">
<div class="title">/home/nicola/public_html/elgg/mod/mtcd/views/default/widgets/recommender/connection.php</div>  </div>
</div>
<div class="contents">
<a href="connection_8php.html">Go to the documentation of this file.</a><div class="fragment"><pre class="fragment"><a name="l00001"></a>00001 &lt;?php
<a name="l00002"></a>00002 
<a name="l00003"></a>00003 <span class="keyword">class </span><a class="code" href="classConnection__mysql.html">Connection_mysql</a>
<a name="l00004"></a>00004 {
<a name="l00005"></a>00005         <span class="comment">// hostname</span>
<a name="l00006"></a><a class="code" href="classConnection__mysql.html#aa381c2f2756c9d98f52006146aa8ff15">00006</a>         <span class="keyword">private</span> <a class="code" href="classConnection__mysql.html#aa381c2f2756c9d98f52006146aa8ff15">$nomehost</a> = <span class="stringliteral">&quot;localhost&quot;</span>;
<a name="l00007"></a>00007         <span class="comment">// utente per la connessione a MySQL</span>
<a name="l00008"></a><a class="code" href="classConnection__mysql.html#a8c184df71c78014258068aa14dfd4047">00008</a>         <span class="keyword">private</span> <a class="code" href="classConnection__mysql.html#a8c184df71c78014258068aa14dfd4047">$nomeuser</a> = <span class="stringliteral">&quot;root&quot;</span>;
<a name="l00009"></a>00009         <span class="comment">// password per l&#39;autenticazione dell&#39;utente</span>
<a name="l00010"></a><a class="code" href="classConnection__mysql.html#a0c460fe7d6d0b86d260446f77dc3f5c6">00010</a>         <span class="keyword">private</span> <a class="code" href="classConnection__mysql.html#a0c460fe7d6d0b86d260446f77dc3f5c6">$password</a> = <span class="stringliteral">&quot;&quot;</span>;
<a name="l00011"></a>00011                 
<a name="l00012"></a><a class="code" href="classConnection__mysql.html#a607475385259326ce0c28046be0feda5">00012</a>         <span class="keyword">private</span> <a class="code" href="classConnection__mysql.html#a607475385259326ce0c28046be0feda5">$mysqli</a>;
<a name="l00013"></a>00013 
<a name="l00014"></a><a class="code" href="classConnection__mysql.html#a70f410272938233474fc6f8586a7c505">00014</a>         <span class="keyword">private</span> <a class="code" href="classConnection__mysql.html#a70f410272938233474fc6f8586a7c505">$query</a>;
<a name="l00015"></a>00015 
<a name="l00016"></a><a class="code" href="classConnection__mysql.html#a368d98b5abf0193f1ca506b097496b32">00016</a>         <span class="keyword">function</span> <a class="code" href="classConnection__mysql.html#a368d98b5abf0193f1ca506b097496b32">__destruct</a>() {
<a name="l00017"></a>00017                 <span class="comment">// chiusura della connessione</span>
<a name="l00018"></a>00018                 $this-&gt;mysqli-&gt;close();
<a name="l00019"></a>00019         }
<a name="l00020"></a>00020                 
<a name="l00021"></a><a class="code" href="classConnection__mysql.html#aa20f8449e316dc0ad733f60918f6aece">00021</a>         <span class="keyword">function</span> <a class="code" href="classConnection__mysql.html#aa20f8449e316dc0ad733f60918f6aece">__construct</a>() {
<a name="l00022"></a>00022                 $this-&gt;mysqli = <span class="keyword">new</span> mysqli($this-&gt;nomehost, $this-&gt;nomeuser, $this-&gt;password , <span class="stringliteral">&quot;elgg&quot;</span>);
<a name="l00023"></a>00023 
<a name="l00024"></a>00024                 <span class="comment">// verifica dell&#39;avvenuta connessione</span>
<a name="l00025"></a>00025                 <span class="keywordflow">if</span> (mysqli_connect_errno()) {
<a name="l00026"></a>00026                         <span class="comment">// notifica in caso di errore</span>
<a name="l00027"></a>00027                         echo <span class="stringliteral">&quot;Errore in connessione al DBMS: &quot;</span>.mysqli_connect_error();
<a name="l00028"></a>00028                         <span class="comment">// interruzione delle esecuzioni i caso di errore</span>
<a name="l00029"></a>00029                         exit();
<a name="l00030"></a>00030                 }
<a name="l00031"></a>00031                 <span class="keywordflow">else</span> {
<a name="l00032"></a>00032                         <span class="comment">// notifica in caso di connessione attiva</span>
<a name="l00033"></a>00033                         <span class="comment">//print(&quot;Connessione avvenuta con successo&quot;);           </span>
<a name="l00034"></a>00034                 }
<a name="l00035"></a>00035         }
<a name="l00036"></a>00036 
<a name="l00037"></a><a class="code" href="classConnection__mysql.html#af1ac1f1cf71a200b3335047da008ab70">00037</a>         <span class="keyword">function</span> <a class="code" href="classConnection__mysql.html#af1ac1f1cf71a200b3335047da008ab70">delete_table</a>()
<a name="l00038"></a>00038         {
<a name="l00039"></a>00039                 $this-&gt;query = <span class="stringliteral">&quot;DROP TABLE IF EXISTS elgg_Persons;&quot;</span>;
<a name="l00040"></a>00040                 $this-&gt;mysqli-&gt;query($this-&gt;query);
<a name="l00041"></a>00041         }
<a name="l00042"></a>00042                 
<a name="l00043"></a>00043 
<a name="l00044"></a><a class="code" href="classConnection__mysql.html#ad52e6ae1a51ac2da1aad1b03c74f69f4">00044</a>         <span class="keyword">function</span> <a class="code" href="classConnection__mysql.html#ad52e6ae1a51ac2da1aad1b03c74f69f4">create_table</a>()
<a name="l00045"></a>00045         {
<a name="l00046"></a>00046                 $this-&gt;query = <span class="stringliteral">&quot;CREATE TABLE IF EXISTS elgg_Persons</span>
<a name="l00047"></a>00047 <span class="stringliteral">                                        (</span>
<a name="l00048"></a>00048 <span class="stringliteral">                                        personID int NOT NULL AUTO_INCREMENT,</span>
<a name="l00049"></a>00049 <span class="stringliteral">                                        PRIMARY KEY(personID),</span>
<a name="l00050"></a>00050 <span class="stringliteral">                                        FirstName varchar(15),</span>
<a name="l00051"></a>00051 <span class="stringliteral">                                        LastName varchar(15),</span>
<a name="l00052"></a>00052 <span class="stringliteral">                                        Age int</span>
<a name="l00053"></a>00053 <span class="stringliteral">                                        );&quot;</span>;    
<a name="l00054"></a>00054 
<a name="l00055"></a>00055                 $this-&gt;mysqli-&gt;query($this-&gt;query);
<a name="l00056"></a>00056         }
<a name="l00057"></a>00057 
<a name="l00058"></a><a class="code" href="classConnection__mysql.html#ad5a4c058fedb89b5bf926b3d3f32486c">00058</a>         <span class="keyword">function</span> <a class="code" href="classConnection__mysql.html#ad5a4c058fedb89b5bf926b3d3f32486c">insert_query</a>($tabella,$campi,$valori)
<a name="l00059"></a>00059         {
<a name="l00060"></a>00060                 $this-&gt;query = <span class="stringliteral">&quot;INSERT INTO &quot;</span> . $tabella . <span class="stringliteral">&quot;(&quot;</span> . $campi . <span class="stringliteral">&quot;) VALUES(&quot;</span> . $valori . <span class="stringliteral">&quot;);&quot;</span>;
<a name="l00061"></a>00061                 <span class="comment">// esecuzione della query</span>
<a name="l00062"></a>00062                 print($this-&gt;query);
<a name="l00063"></a>00063                 $result = $this-&gt;mysqli-&gt;query($this-&gt;query);
<a name="l00064"></a>00064                 $righe_modificate = $this-&gt;mysqli-&gt;affected_rows;
<a name="l00065"></a>00065                 <span class="keywordflow">return</span> $righe_modificate;
<a name="l00066"></a>00066         }
<a name="l00067"></a>00067 
<a name="l00068"></a><a class="code" href="classConnection__mysql.html#a541200dd8823e3db554fd456002546bf">00068</a>         <span class="keyword">function</span> <a class="code" href="classConnection__mysql.html#a541200dd8823e3db554fd456002546bf">Update_query</a>($tabella,$filtri,$condizione)
<a name="l00069"></a>00069         {
<a name="l00070"></a>00070                 <span class="comment">// query argomento del metodo query()</span>
<a name="l00071"></a>00071                 $this-&gt;query = <span class="stringliteral">&quot;UPDATE &quot;</span> . $tabella . <span class="stringliteral">&quot; SET &quot;</span> . $filtri;
<a name="l00072"></a>00072 
<a name="l00073"></a>00073                 <span class="keywordflow">if</span>($condizione &lt;&gt; <span class="stringliteral">&quot;&quot;</span>)
<a name="l00074"></a>00074                 {
<a name="l00075"></a>00075                         $this-&gt;query .= <span class="stringliteral">&quot; WHERE &quot;</span> . $condizione;
<a name="l00076"></a>00076                 }
<a name="l00077"></a>00077                 
<a name="l00078"></a>00078                 <span class="comment">// esecuzione della query</span>
<a name="l00079"></a>00079                 $result = $this-&gt;mysqli-&gt;query($this-&gt;query);
<a name="l00080"></a>00080                 $righe_modificate = $this-&gt;mysqli-&gt;affected_rows;
<a name="l00081"></a>00081                 <span class="keywordflow">if</span>($result == <span class="keyword">false</span>)
<a name="l00082"></a>00082                 {
<a name="l00083"></a>00083                         print(<span class="stringliteral">&quot;Query failed: &quot;</span> . $this-&gt;query);
<a name="l00084"></a>00084 
<a name="l00085"></a>00085                 }
<a name="l00086"></a>00086 
<a name="l00087"></a>00087                 <span class="keywordflow">return</span> $righe_modificate;
<a name="l00088"></a>00088                 <span class="comment">/*// conteggio dei record restituiti dalla query</span>
<a name="l00089"></a>00089 <span class="comment">                 if($result-&gt;num_rows &gt;0)</span>
<a name="l00090"></a>00090 <span class="comment">                {</span>
<a name="l00091"></a>00091 <span class="comment">                //generazione di un array numerico</span>
<a name="l00092"></a>00092 <span class="comment">                while($row = $result-&gt;fetch_array(MYSQLI_NUM))</span>
<a name="l00093"></a>00093 <span class="comment">                {</span>
<a name="l00094"></a>00094 <span class="comment">                echo $row[0];</span>
<a name="l00095"></a>00095 <span class="comment">                echo &quot;&lt;br /&gt;\n&quot;;</span>
<a name="l00096"></a>00096 <span class="comment">                }</span>
<a name="l00097"></a>00097 <span class="comment">                }*/</span>
<a name="l00098"></a>00098                         
<a name="l00099"></a>00099                 <span class="comment">// liberazione delle risorse occupate dal risultato</span>
<a name="l00100"></a>00100                 <span class="comment">//$result-&gt;close();             </span>
<a name="l00101"></a>00101         }
<a name="l00102"></a>00102 
<a name="l00103"></a><a class="code" href="classConnection__mysql.html#a7bbdf829b6ed80acbdc6737553aacc05">00103</a>         <span class="keyword">function</span> <a class="code" href="classConnection__mysql.html#a7bbdf829b6ed80acbdc6737553aacc05">select_query</a>($tabella,$filtri,$condizione)
<a name="l00104"></a>00104         {       
<a name="l00105"></a>00105                 <span class="comment">// query argomento del metodo query()</span>
<a name="l00106"></a>00106                 <span class="keywordflow">if</span>($filtri == <span class="stringliteral">&quot;&quot;</span>)
<a name="l00107"></a>00107                 {
<a name="l00108"></a>00108                         $this-&gt;query = <span class="stringliteral">&quot;SELECT *&quot;</span>;
<a name="l00109"></a>00109                 }
<a name="l00110"></a>00110                 <span class="keywordflow">else</span>
<a name="l00111"></a>00111                 {
<a name="l00112"></a>00112                         $this-&gt;query = <span class="stringliteral">&quot;SELECT &quot;</span> . $filtri;
<a name="l00113"></a>00113                 }
<a name="l00114"></a>00114                 
<a name="l00115"></a>00115                 $this-&gt;query .= <span class="stringliteral">&quot; FROM &quot;</span> . $tabella;
<a name="l00116"></a>00116                 
<a name="l00117"></a>00117                 <span class="keywordflow">if</span>($condizione &lt;&gt; <span class="stringliteral">&quot;&quot;</span>)
<a name="l00118"></a>00118                 {
<a name="l00119"></a>00119                         $this-&gt;query .= <span class="stringliteral">&quot; WHERE &quot;</span> . $condizione;
<a name="l00120"></a>00120                 }
<a name="l00121"></a>00121                 
<a name="l00122"></a>00122                 <span class="comment">// esecuzione della query</span>
<a name="l00123"></a>00123                 $result = $this-&gt;mysqli-&gt;query($this-&gt;query);
<a name="l00124"></a>00124 
<a name="l00125"></a>00125                 <span class="comment">//print($this-&gt;query);</span>
<a name="l00126"></a>00126 
<a name="l00127"></a>00127                 <span class="keywordflow">if</span>($result == null)
<a name="l00128"></a>00128                 {
<a name="l00129"></a>00129                         print(<span class="stringliteral">&quot;Risultato nullo in connection&quot;</span>);
<a name="l00130"></a>00130                 }
<a name="l00131"></a>00131 
<a name="l00132"></a>00132                 <span class="keywordflow">if</span>($result == <span class="keyword">false</span>)
<a name="l00133"></a>00133                 {
<a name="l00134"></a>00134                         echo(<span class="stringliteral">&quot;Query failed: &quot;</span> . $this-&gt;query);
<a name="l00135"></a>00135 
<a name="l00136"></a>00136                 }
<a name="l00137"></a>00137 
<a name="l00138"></a>00138                 <span class="keywordflow">return</span> $result;
<a name="l00139"></a>00139                 <span class="comment">/*// conteggio dei record restituiti dalla query</span>
<a name="l00140"></a>00140 <span class="comment">                 if($result-&gt;num_rows &gt;0)</span>
<a name="l00141"></a>00141 <span class="comment">                {</span>
<a name="l00142"></a>00142 <span class="comment">                //generazione di un array numerico</span>
<a name="l00143"></a>00143 <span class="comment">                while($row = $result-&gt;fetch_array(MYSQLI_NUM))</span>
<a name="l00144"></a>00144 <span class="comment">                {</span>
<a name="l00145"></a>00145 <span class="comment">                echo $row[0];</span>
<a name="l00146"></a>00146 <span class="comment">                echo &quot;&lt;br /&gt;\n&quot;;</span>
<a name="l00147"></a>00147 <span class="comment">                }</span>
<a name="l00148"></a>00148 <span class="comment">                }*/</span>
<a name="l00149"></a>00149                         
<a name="l00150"></a>00150                 <span class="comment">// liberazione delle risorse occupate dal risultato</span>
<a name="l00151"></a>00151                 <span class="comment">//$result-&gt;close();             </span>
<a name="l00152"></a>00152         }
<a name="l00153"></a>00153 }
<a name="l00154"></a>00154 ?&gt;
</pre></div></div>
</div>
  <div id="nav-path" class="navpath">
    <ul>
      <li class="navelem"><a class="el" href="connection_8php.html">connection.php</a>      </li>
<!-- window showing the filter options -->
<div id="MSearchSelectWindow"
     onmouseover="return searchBox.OnSearchSelectShow()"
     onmouseout="return searchBox.OnSearchSelectHide()"
     onkeydown="return searchBox.OnSearchSelectKey(event)">
<a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(0)"><span class="SelectionMark">&#160;</span>All</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(1)"><span class="SelectionMark">&#160;</span>Classes</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(2)"><span class="SelectionMark">&#160;</span>Files</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(3)"><span class="SelectionMark">&#160;</span>Functions</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(4)"><span class="SelectionMark">&#160;</span>Variables</a></div>

<!-- iframe showing the search results (closed by default) -->
<div id="MSearchResultsWindow">
<iframe src="javascript:void(0)" frameborder="0" 
        name="MSearchResults" id="MSearchResults">
</iframe>
</div>


    <li class="footer">Generated on Mon Feb 13 2012 14:42:24 for MTCDElggPlugin by
    <a href="http://www.doxygen.org/index.html">
    <img class="footer" src="doxygen.png" alt="doxygen"/></a> 1.7.5 </li>
   </ul>
 </div>


</body>
</html>
